UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bp4ATobqjKrIMV2f9zzrMX/zwhUveoWM5DC9L2DEPkc='
WHERE
key_id = '87278beafb7565301a877e6320d6416beee1d4c97ca805e7792407b75250e7d6'
AND (
token = 'Bp4ATobqjKrIMV2f9zzrMX/zwhUveoWM5DC9L2DEPkc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)