UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MJtHJ897vzMjgo0ru886fEnD3M4MJzLVrXb8Ge1C5Xs='
WHERE
key_id = '42e3c00e459fe9757e7994674ef4401a2764dda7dd58f107e8e1a2cc97db2b5e'
AND (
token = 'MJtHJ897vzMjgo0ru886fEnD3M4MJzLVrXb8Ge1C5Xs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)