UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ns9RTB2Ze3VorEAW9qnbtbXLefH1bl9We1jMcG7iY8g='
WHERE
key_id = '2b982164652007f05b67dbb8cb949dbd21a5f8dad2de2f01b7a4dc6ac9a45988'
AND (
token = 'ns9RTB2Ze3VorEAW9qnbtbXLefH1bl9We1jMcG7iY8g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)