UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V2gDgH95hbXrd4b/97nLPTDVE+X9lk4oI2DFLLNOemM='
WHERE
key_id = '7a9aac696a4f67718d72f8086df51aa7715497f9b94c10c41f2537dc39517cf2'
AND (
token = 'V2gDgH95hbXrd4b/97nLPTDVE+X9lk4oI2DFLLNOemM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)