UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vGPxhVCW0tryYYPGv4fXE8JSDB+tcj24Mhij6doN3Y0='
WHERE
key_id = 'd541184b90f9e85d37a7e3f08ac181c9ae3813b3211d01f775be25ef155db807'
AND (
token = 'vGPxhVCW0tryYYPGv4fXE8JSDB+tcj24Mhij6doN3Y0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)