UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NcKjsyiFOgvLGO04Y57THmZQne8hm+YGwmjwGkDKOYw='
WHERE
key_id = 'd4c79a7c001b0c14f1852e12a580f4f4098204cc38733685b2c6d938a80dfe4c'
AND (
token = 'NcKjsyiFOgvLGO04Y57THmZQne8hm+YGwmjwGkDKOYw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)