UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0PgCJpiB1dbi6Mk3sx1rQGSPm55KNHWhb9cQkYePftg='
WHERE
key_id = '14565dd6eec4cf90e070f1d426e1ae51a8142d530c1e64172697dbce3d108aa1'
AND (
token = '0PgCJpiB1dbi6Mk3sx1rQGSPm55KNHWhb9cQkYePftg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)