UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8NmU4Wjd2KvezCDweHIuJpepNA7ib+61lCdaVNrNz8g='
WHERE
key_id = '3701c2a27eb46d2bd0abab1773d895fcfcde6a6b24b364c13a6cad6ed285c8e2'
AND (
token = '8NmU4Wjd2KvezCDweHIuJpepNA7ib+61lCdaVNrNz8g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)