UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hp8cYt/pGpyTyWpY6AqI2wdjJSSin8b2N0sHHtZrSms='
WHERE
key_id = '7bb93dcae197182286dc68dcee095a10ae327b4a7e14fe383507d03f31105e95'
AND (
token = 'Hp8cYt/pGpyTyWpY6AqI2wdjJSSin8b2N0sHHtZrSms='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)