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