UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mIhRMMXjiW+b1SkvnHjU9N40luE7vRpuVYqMWU+hXYQ='
WHERE
key_id = '207a4b92f4c7ce21a597762a8fb149acc7a03e476616d564e2ca3a0296e7f0ea'
AND (
token = 'mIhRMMXjiW+b1SkvnHjU9N40luE7vRpuVYqMWU+hXYQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)