UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bGze5GZHxg75rXUkFr53Anezm9oKTudRHIDWlV7OuXk='
WHERE
key_id = '9d2ec0d969b08332bcee37c2a5ab28f882621519227198dead7dc6d95d19c3bf'
AND (
token = 'bGze5GZHxg75rXUkFr53Anezm9oKTudRHIDWlV7OuXk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)