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