UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xdIpbj+4tF2buYwyucqjsRfjdn6z528TSZVQOSkDGY0='
WHERE
key_id = '24c31f64f16dddb6d3812e3dc2b3fdba3252507f1ef5746d93f5afe42271f645'
AND (
token = 'xdIpbj+4tF2buYwyucqjsRfjdn6z528TSZVQOSkDGY0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)