UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5XNeeq8Pe38plYxy9kUgt2YeHCEpeF4hC3yDFIHbVMs='
WHERE
key_id = '6baccfba823726ac0fa8d850700e336eb97d9250f60da79aa9596042d5a23fda'
AND (
token = '5XNeeq8Pe38plYxy9kUgt2YeHCEpeF4hC3yDFIHbVMs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)