UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zapw2AHJUUE00XZdZJMfkz6pnGJM4wxRyJB8QK10xWI='
WHERE
key_id = 'fdbdc3e3c26b1e406d5f120d32d4b8c0027cb82f4f564224f52680174788c869'
AND (
token = 'Zapw2AHJUUE00XZdZJMfkz6pnGJM4wxRyJB8QK10xWI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)