UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D/D++z/KOidnfXnE64Mvt2ZTQ3Myv7W15NZ9zBzi+hY='
WHERE
key_id = '1b18de401b56c2a07e069cd027a891480ed771a3638592d22f8f855cb57cf76d'
AND (
token = 'D/D++z/KOidnfXnE64Mvt2ZTQ3Myv7W15NZ9zBzi+hY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)