UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pCBMg6UD6ljOb7YobahbSpwOtQLUjLP5tDfew5ZZkms='
WHERE
key_id = '7bba1fe2e2932eb498c4a8610cb82aa56a884b5515d8adacc1630ea36d5fbb4c'
AND (
token = 'pCBMg6UD6ljOb7YobahbSpwOtQLUjLP5tDfew5ZZkms='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)