UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q7bNgeNOVcrkUxszyEGKnzxLzcMQHuS85RUNopK6YB0='
WHERE
key_id = '6da234d37b865cff4f71ee89dbd205e334062096623710c0b21517081900b2fc'
AND (
token = 'q7bNgeNOVcrkUxszyEGKnzxLzcMQHuS85RUNopK6YB0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)