UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MApv20Xa6nwVU6MFrOB3DmKu4S3j1STWSdYPpGu28m8='
WHERE
key_id = '5884f8db58de0249fdc61a7e2356ab59462caec8504f3d3152172f2baa6f7772'
AND (
token = 'MApv20Xa6nwVU6MFrOB3DmKu4S3j1STWSdYPpGu28m8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)