UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bXxCZpBkTo6f38w0ZZYgbNbNWUApSElQalh5w1Dp0VQ='
WHERE
key_id = 'b0193165c0a93897af3dca20f01a889ea117dca944734851f61016cd0ef552ff'
AND (
token = 'bXxCZpBkTo6f38w0ZZYgbNbNWUApSElQalh5w1Dp0VQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)