UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8zq7tAjsLPtlI1/xKOoZZcVEt1MkI22DZ+IPyKLkbD8='
WHERE
key_id = '9d4d7d49318907685965f861beb30b8101e8a0f098ebf8c5f9cd3c18de5a8206'
AND (
token = '8zq7tAjsLPtlI1/xKOoZZcVEt1MkI22DZ+IPyKLkbD8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)