UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xBIHPj+Fd/naWUBvb1rDV0IVZV7CCcxehbKtCsGSPKo='
WHERE
key_id = '1c22f17acacd9153c7e565383c8618cd82ada9de57c8be42702af1d8b45b9928'
AND (
token = 'xBIHPj+Fd/naWUBvb1rDV0IVZV7CCcxehbKtCsGSPKo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)