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