UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Sg8eEXYSYgK8tiJQkf1o4j9X+tzHYh42V4Nll520iGI='
WHERE
key_id = 'aa35f1184e79204ad842da84c8d9a1c985e12199a8eb8c2eccb23526f9211aad'
AND (
token = 'Sg8eEXYSYgK8tiJQkf1o4j9X+tzHYh42V4Nll520iGI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)