UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xuP+dIf7+J8bBq6ADpRwu2K+XAwUmitb8z22dabXCto='
WHERE
key_id = '71a26404363b6553f8a21671f400693d2a29ec0825d2bb7c8497ebbbcec9f79f'
AND (
token = 'xuP+dIf7+J8bBq6ADpRwu2K+XAwUmitb8z22dabXCto='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)