UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JOrTYwPEkk0aYLsCZsT4X0ufL+s7O+CIJYpzZKy05oc='
WHERE
key_id = 'c2947d821616622681b7436b1fe28fbec660c4377282658632dd8e9644992cc8'
AND (
token = 'JOrTYwPEkk0aYLsCZsT4X0ufL+s7O+CIJYpzZKy05oc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)