UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f/FPSOVLXFJ093ebWfZeATXOGmi3auQ9QiFihYSzGqg='
WHERE
key_id = 'a65a9e188dbf78a6199dc2c9714de82a083e2a055b7feba1caad9d312c215796'
AND (
token = 'f/FPSOVLXFJ093ebWfZeATXOGmi3auQ9QiFihYSzGqg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)