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