UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '512a0ExrKticC/ZuBUynebRPOS3cpgANgTBhY20CD3o='
WHERE
key_id = 'cb1fb50c851d9ab48f5245dbd7b7e22f981559fde8a26c6d769ce8b6eb6bebc1'
AND (
token = '512a0ExrKticC/ZuBUynebRPOS3cpgANgTBhY20CD3o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)