UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NzvbKGWtX2tlEHegX54CsIbaec8hi3QUMMB2hdRyDmc='
WHERE
key_id = 'ccdca8e1869d6d075c3acc0b5865a1d4bd562ca01719e03ea629579b2b6e1190'
AND (
token = 'NzvbKGWtX2tlEHegX54CsIbaec8hi3QUMMB2hdRyDmc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)