UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZwYwFeJy8opq/D6gk3lJ9lJa5NGS1eGTVjc13Z9bG/Y='
WHERE
key_id = 'd870d2a6282f180746af92c35f5d4ddcbb7167534ffa2b4ff32beb077abfbfc0'
AND (
token = 'ZwYwFeJy8opq/D6gk3lJ9lJa5NGS1eGTVjc13Z9bG/Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)