UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NTKanZnQcsgql0bTP9pl8Mx3hCzTs/B5x0R/4z/+GNY='
WHERE
key_id = 'a93eec5e581ecf6ca658eeb470f7a293ffa2b1ae665556c56c200753f35e0634'
AND (
token = 'NTKanZnQcsgql0bTP9pl8Mx3hCzTs/B5x0R/4z/+GNY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)